Use this code to rename the excel sheet through coding, http://stackoverflow.com/questions/6698606/rename-the-excel-sheet-name-in-c-sharp this concept is implement in ssrs 2008 R2, http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

Hi Gunasekaran, Do you have any questions related to renaming the sheets of an excel export? The second link above provides a solution to doing so. I don't know if I am missing something here, but can you let us know if you are looking out for any kind of help from us? Cheers, IceQBPlease mark correct answers :)

hi IceQB, thank u for u response we using the reporting server 2008, our issue is we using same RDL file for Two report, during the excel export the sheet name is same as RDL Name, we set one report name as RDL Name, But another report also come same, how to given the seperate Excel sheet for different report using same RDL ?

we using the reporting server 2008, our issue is we using same RDL file for Two report, during the excel export the sheet name is same as RDL Name, we set one report name as RDL Name, But another report also come same, how to given the seperate Excel sheet for different report using same RDL ? You can implement a report parameter that accepts the name of the sheet. When calling the report, pass in the appropriate value through the parameter. In the report, use the parameter in an expression in the InitialPageName property. More details on naming Excel sheets: http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)